package com.stedu.service;

import com.github.pagehelper.PageInfo;
import com.stedu.bean.Employee;

import java.sql.SQLException;
import java.util.List;

public interface EmployeeService {

    PageInfo findByPage(int currentPage, String ename, String ejob);
    //根据部门ID查询员工
    List<Employee> findByDid(Integer did);

    Employee findById(Integer eid);
    //添加
    void add(Employee employee) throws Exception;
    //查询最大工号
    String maxEno() throws SQLException;
    int chgEstate(Integer eid,Integer estate);
    int update(Employee employee);
}
